USE [Publicate]
GO

/****** Object:  Table [dbo].[Imagenes]    Script Date: 11/05/2012 14:42:27 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[Imagenes](
	[Id_Imagenes] [int] IDENTITY(1,1) NOT NULL,
	[Id_Propiedad] [int] NOT NULL,
	[SRC] [varchar](200) NOT NULL,
	[CreatedDate] [datetime] NOT NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[Imagenes] ADD  CONSTRAINT [DF_Imagenes_CreatedDate]  DEFAULT (getdate()) FOR [CreatedDate]
GO


--Agregar la nueva columna de URLVideo a la tabla Propiedades
ALTER TABLE [dbo].[Propiedades]
ADD URLVideo varchar(50)
GO